﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetVehiculoByNroPlaca')
	BEGIN
		DROP  Procedure  GetVehiculoByNroPlaca
	END

GO

CREATE Procedure GetVehiculoByNroPlaca

	(
		@nroPlaca nvarchar(10)
	)

AS

BEGIN
	SET NOCOUNT ON
	
	SELECT
	[IdBien],
	[Marca],
	[Modelo],
	[NroPlaca],
	[TipoVehiculo]
	FROM [Vehiculo] 
	WHERE [NroPlaca] = @nroPlaca

	SET NOCOUNT OFF
END

GO


GRANT EXEC ON GetVehiculoByNroPlaca TO PUBLIC

GO

